Le photoblog de Jeff

Table 'evo_sessions' is marked as crashed and should be repaired(Errno=1194)

Your query: Sessions: get list of relevant users.

SELECT SQL_NO_CACHE sess_user_ID

  FROM evo_sessions

 WHERE sess_lastseen_ts > '2025-11-15 14:53:03'

   AND sess_key IS NOT NULL

 GROUP BY sess_ID

Table 'evo_hitlog' is marked as crashed and should be repaired(Errno=1194)

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-11-15 00:00:00'

 GROUP BY hit_date, hit_coll_ID, hit_type, hit_referer_type, hit_agent_type