/media/sda-magnetic/david/Dok-15-2023-11-27/fernuni-hagen/cs-i-ii/old-cs-2-02/statistik2022-06-10/something/safe.txt

SELECT ip, COUNT(*) FROM ip_datetime WHERE datetime >= DATE_SUB(NOW(), INTERVAL 1 DAY) GROUP BY ip ORDER BY COUNT(*) DESC LIMIT 10;

SELECT ip, COUNT(ip) FROM ip_datetime WHERE EXISTS (SELECT ip, COUNT(*) FROM ip_datetime WHERE datetime >= DATE_SUB(NOW(), INTERVAL 1 DAY) GROUP BY ip ORDER BY COUNT(*) DESC LIMIT 1) AND datetime >= DATE_SUB(NOW(), INTERVAL 1 HOUR) GROUP BY ip ORDER BY COUNT(ip);

SELECT ip FROM ip_datetime JOIN ip ip_datetime


SELECT ip, COUNT(*) FROM ip_datetime WHERE datetime >= DATE_SUB(NOW(), INTERVAL 1 DAY) GROUP BY ip ORDER BY COUNT(*) DESC LIMIT 8,3;

SELECT * FROM ip_datetime WHERE EXISTS (SELECT ip, COUNT(*) FROM ip_datetime WHERE datetime >= DATE_SUB(NOW(), INTERVAL 1 DAY) GROUP BY ip ORDER BY COUNT(*) DESC LIMIT 8,3);

SELECT ip FROM stat_track.ip_datetime WHERE stat_track.ip_datetime.datetime >= DATE_SUB(NOW(), INTERVAL 23 HOUR) AND ip IN (SELECT ip FROM mytrack.ips WHERE mytrack.ips.geo = "GeoIP Country Edition: RU, Russian Federation");