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-07-29 02:55:07' AND `stat_data`.`datetime` <= '2026-07-29 03:55:07'   AND stat_data.request = '/'
GROUP BY stat_data.client
ORDER BY count_client DESC
LIMIT  200

Запросы на /