SELECT
  COUNT(stat_data.client) AS count_client,
  stat_data.client,
  stat_data.request,
  host.host,
  host.lie,
  host.country
FROM stat_data
  INNER JOIN host
    ON stat_data.client = host.ip
WHERE  `stat_data`.`server_id` = '1'  AND `stat_data`.`datetime` >= '2026-09-23 04:16:29' AND `stat_data`.`datetime` <= '2026-09-23 05:16:29'   AND stat_data.request = '/rss/news.xml'
GROUP BY stat_data.client
ORDER BY count_client DESC
LIMIT  200

Запросы на /rss/news.xml