Campagnes

Duplicate entry '61546156' for key 'PRIMARY'(Errno=1062)

Your query: Aggregate hits log

REPLACE INTO evo_hits__aggregate ( hagg_date, hagg_coll_ID, hagg_type, hagg_referer_type, hagg_agent_type, hagg_count )

SELECT DATE( hit_datetime ) AS hit_date, IFNULL( hit_coll_ID, 0 ), hit_type, hit_referer_type, hit_agent_type, COUNT( hit_ID )

  FROM evo_hitlog

 WHERE hit_datetime < '2025-01-20 00:00:00'

 GROUP BY hit_date, hit_coll_ID, hit_type, hit_referer_type, hit_agent_type