| #207 | $keys = []; |
| #208 | $i = 0; |
| #209 | while ($i < $limit) { |
| #210 | if ($cid > 0) { |
| #211 | $sql = "SELECT t1.id FROM {$table_full} AS t1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM {$table_full} WHERE cid = $cid)) AS id) AS t2 WHERE t1.id >= t2.id AND t1.cid = $cid LIMIT 1"; |
| #212 | } else { |
| #213 | $sql = "SELECT t1.id FROM {$table_full} AS t1 |
| #214 | JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM {$table_full})) AS id) AS t2 |
| #215 | WHERE t1.id >= t2.id |
| #216 | LIMIT 1"; |