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:14' AND `stat_data`.`datetime` <= '2026-06-12 15:54:14'   AND stat_data.request = '/index.php?/categories/created-weekly-list-2012-35-2&lang=z'
GROUP BY stat_data.client
ORDER BY count_client DESC
LIMIT  200

Запросы на /index.php?/categories/created-weekly-list-2012-35-2&lang=z