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 14:54:34' AND `stat_data`.`datetime` <= '2026-06-12 15:54:34'   AND stat_data.request = '/'
GROUP BY stat_data.client
ORDER BY count_client DESC
LIMIT  200

Запросы на /