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"); ;