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-06-12 12:53:47' AND `stat_data`.`datetime` <= '2026-06-12 13:53:47'   AND stat_data.request = '/xmlrpc.php'
GROUP BY stat_data.client
ORDER BY count_client DESC
LIMIT  200

Запросы на /xmlrpc.php