NOW() - INTERVAL 1 DAY ORDER BY RAND() LIMIT 50 ) UNION ( SELECT DomainDetail.`UTCLastVerified`, DomainDetail.`UTCLevelLastChanged`, DomainDetail.`Rating`, DomainDetail.`Target`, Domain.Host FROM `DomainDetail` LEFT JOIN Domain ON Domain.ID = DomainDetail.DomainID WHERE DomainDetail.`Rating` != 'Unknown' AND DomainDetail.`UTCLastVerified` <= NOW() - INTERVAL 1 DAY ORDER BY RAND() LIMIT 2700 ) ORDER BY RAND();"; $r = $db->query($sql); echo ''; echo ''; if($r) { while($row = $r->fetch_assoc()){ $ts = strtotime($row['UTCLastVerified'] ?? ''); $lastmod = ($ts > 0) ? date('Y-m-d', $ts) : date('Y-m-d'); echo ''; echo 'https://icr.chit.eu/check/' . htmlspecialchars($row['Host']) . ''; echo '' . $lastmod . ''; echo 'monthly'; echo '0.3'; echo ''; } } echo ''; $db->close(); ?>